export const getOrgListByParent = `select
  org_id as orgId,
  org_name as orgName,
  parent_id as parentId,
  org_manage as orgManage
  from organization
  where parent_id = :parentId and p_delete = 0
  order by create_time
`;
export const createOrg = `insert into organization
  (org_id, org_name, parent_id, org_manage)
  values (:orgId, :orgName, :parentId, :orgManage)
`;
export const removeOrg = `delete form organization
  where org_id = :orgId
`;
export const saveOrg = `update organization set
  org_name = :orgName,
  parent_id = :parentId,
  org_manage = :orgManage
  where org_id = :orgId
`;
